inherited fm_Tmp_Etiqueta: Tfm_Tmp_Etiqueta
  Caption = 'Hist'#243'rico de Gera'#231#227'o de Etiqueta'
  ClientHeight = 466
  ClientWidth = 811
  OnShow = FormShow
  ExplicitWidth = 827
  ExplicitHeight = 504
  PixelsPerInch = 96
  TextHeight = 13
  object Splitter1: TSplitter
    Left = 0
    Top = 169
    Width = 811
    Height = 9
    Cursor = crVSplit
    Align = alTop
    Beveled = True
  end
  object Panel1: TPanel
    Left = 0
    Top = 178
    Width = 811
    Height = 288
    Align = alClient
    TabOrder = 0
    object DBGrid_Tmp_Etiqueta_Item: TFocusDBGrid
      Left = 1
      Top = 1
      Width = 809
      Height = 286
      Align = alClient
      Color = clWindow
      Columns = <
        item
          Expanded = False
          FieldName = 'ie_impresso'
          Font.Charset = ANSI_CHARSET
          Font.Color = clWindowText
          Font.Height = -1
          Font.Name = 'Arial Narrow'
          Font.Style = []
          Title.Caption = 'Impresso'
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'nr_sequencial'
          Title.Caption = 'C'#243'd.'
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'nr_cliente_seq'
          Title.Caption = 'Seq.Cliente'
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'nr_conjunto'
          Title.Caption = 'N'#186' Conjunto'
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'ds_volume'
          Title.Caption = 'Volume'
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'C'#243'digo'
          Title.Caption = 'C'#243'd.Produto'
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'Produto'
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'ds_Caixa'
          Title.Caption = 'Caixa'
          Visible = True
        end>
      DrawingStyle = gdsGradient
      Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit, dgTitleClick, dgTitleHotTrack]
      ReadOnly = True
      TabOrder = 0
      TitleFont.Charset = DEFAULT_CHARSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -11
      TitleFont.Name = 'Tahoma'
      TitleFont.Style = []
      ColorParStart = clCream
      ColorParEnd = clWhite
      ColorImparStart = clWhite
      ColorImparEnd = clCream
      SQL.Strings = (
        'SELECT a.*'
        'FROM ('
        'SELECT a.nr_sequencia As nr_sequencial,'
        #9#9' a.nr_cliente_seq,'
        #9#9' a.nr_conjunto,'
        #9#9' a.ds_volume,'
        #9#9' a.ie_imprimir,'
        #9#9'a.ie_impresso,'
        #9#9'e.prc'#243'digoproduto As C'#243'digo,'
        #9#9'e.prproduto As Produto,'
        #9#9'b.ds_caixa'
        'FROM'#9'(((tmp_etiqueta a'
        'INNER JOIN caixa b On b.nr_sequencia = a.nr_seq_caixa)'
        'INNER JOIN orcamento_item c On a.nr_seq_orcamento_item = c.id)'
        
          'INNER JOIN orcamento d On d.n'#250'meroor'#231'amento = c.don'#250'meroor'#231'ament' +
          'o) '
        'INNER JOIN produto e On e.prc'#243'digoproduto = c.c'#243'digoproduto'
        'WHERE'#9'Exists('#9'SELECT 1 '
        'FROM '#9'orcamento_item w'
        'WHERE'#9'w.doN'#250'meroOr'#231'amento = :N'#250'meroOr'#231'amento'
        'And'#9'w.id = a.nr_seq_orcamento_item)'
        ' )a WHERE 1=1')
      Params = <
        item
          DataType = ftInteger
          Name = 'N'#250'meroOr'#231'amento'
          ParamType = ptInput
        end>
      TipoClasseBase = TTmp_Etiqueta
      TipoClasseDestino = Null
      Columns = <
        item
          Expanded = False
          FieldName = 'ie_impresso'
          Font.Charset = ANSI_CHARSET
          Font.Color = clWindowText
          Font.Height = -1
          Font.Name = 'Arial Narrow'
          Font.Style = []
          Title.Caption = 'Impresso'
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'nr_sequencial'
          Title.Caption = 'C'#243'd.'
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'nr_cliente_seq'
          Title.Caption = 'Seq.Cliente'
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'nr_conjunto'
          Title.Caption = 'N'#186' Conjunto'
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'ds_volume'
          Title.Caption = 'Volume'
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'C'#243'digo'
          Title.Caption = 'C'#243'd.Produto'
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'Produto'
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'ds_Caixa'
          Title.Caption = 'Caixa'
          Visible = True
        end>
    end
  end
  object Panel2: TPanel
    Left = 0
    Top = 0
    Width = 811
    Height = 169
    Align = alTop
    TabOrder = 1
    object DBGrid_Tmp_Etiqueta: TFocusDBGrid
      Left = 1
      Top = 1
      Width = 809
      Height = 167
      Align = alClient
      Color = clWindow
      DrawingStyle = gdsGradient
      Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit, dgTitleClick, dgTitleHotTrack]
      ReadOnly = True
      TabOrder = 0
      TitleFont.Charset = DEFAULT_CHARSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -11
      TitleFont.Name = 'Tahoma'
      TitleFont.Style = []
      ColorParStart = clCream
      ColorParEnd = clWhite
      ColorImparStart = clWhite
      ColorImparEnd = clCream
      SQL.Strings = (
        'select '#9'a.n'#250'meroor'#231'amento,'
        #9'count(a.n'#250'meroor'#231'amento) as qt,'
        #9'd.cliente '
        'from'#9'(((orcamento '#9' a   '
        
          'inner '#9'join orcamento_item b on b.don'#250'meroor'#231'amento = a.n'#250'meroor' +
          #231'amento)'
        'inner'#9'join tmp_etiqueta '#9' c on c.nr_seq_orcamento_item = b.id)'
        'inner join cliente '#9#9' d on d.c'#243'digocliente = a.orc'#243'digocliente)'
        'group by a.n'#250'meroor'#231'amento,d.cliente')
      SubDetail = DBGrid_Tmp_Etiqueta_Item
      Params = <>
      TipoClasseBase = TTmp_Etiqueta
      TipoClasseDestino = Null
    end
  end
end
